--Add Name column to player table
Alter table Player add [Name] nvarchar(100)
Go
update Player
set [Name] = FirstName + ' ' + LastName
where PlayerId = PlayerId
Go
update Player
set LastName = [Name], FirstName = ''
where PlayerId = PlayerId

Alter Table Player drop column [Name]
Alter Table Player alter column [LastName] nvarchar(100) 